{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form","Instructions"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form","index":0,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,0,59,1],[59,2,59,3],[59,4,59,5],[59,9,59,10],[57,0,57,1],[57,2,57,3],[57,4,57,5],[57,9,57,10],[58,0,58,1],[58,2,58,3],[58,4,58,5],[58,9,58,10],[52,9,52,10],[49,9,49,10],[50,0,50,1],[50,2,50,3],[50,4,50,5],[50,9,50,10],[55,9,55,10],[56,0,56,1],[56,2,56,3],[56,4,56,5],[56,9,56,10],[53,9,53,10],[54,0,54,1],[54,2,54,3],[54,4,54,5],[54,9,54,10],[47,9,47,10],[48,0,48,1],[48,2,48,3],[48,4,48,5],[48,9,48,10],[55,0,55,1],[55,2,55,3],[55,4,55,5],[53,0,53,1],[53,2,53,3],[53,4,53,5],[51,0,51,1],[51,2,51,3],[51,4,51,5],[49,0,49,1],[49,2,49,3],[49,4,49,5],[47,0,47,1],[47,2,47,3],[47,4,47,5],[51,9,51,10],[52,0,52,1],[52,2,52,3],[52,4,52,5],[45,0,45,1],[45,2,45,3],[45,4,45,5],[45,9,45,10],[46,0,46,1],[46,2,46,3],[46,4,46,5],[46,9,46,10],[43,0,43,1],[43,2,43,3],[43,4,43,5],[43,9,43,10],[44,0,44,1],[44,2,44,3],[44,4,44,5],[44,9,44,10],[41,0,41,1],[41,2,41,3],[41,4,41,5],[41,9,41,10],[42,0,42,1],[42,2,42,3],[42,4,42,5],[42,9,42,10],[39,0,39,1],[39,2,39,3],[39,4,39,5],[39,9,39,10],[40,0,40,1],[40,2,40,3],[40,4,40,5],[40,9,40,10],[37,0,37,1],[37,2,37,3],[37,4,37,5],[37,9,37,10],[38,0,38,1],[38,2,38,3],[38,4,38,5],[38,9,38,10],[35,0,35,1],[35,2,35,3],[35,4,35,5],[35,9,35,10],[36,0,36,1],[36,2,36,3],[36,4,36,5],[36,9,36,10],[33,0,33,1],[33,2,33,3],[33,4,33,5],[33,9,33,10],[34,0,34,1],[34,2,34,3],[34,4,34,5],[34,9,34,10],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,9,31,10],[32,0,32,1],[32,2,32,3],[32,4,32,5],[32,9,32,10],[25,8,25,9],[25,1,25,3],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[14,0,14,1],[15,0,15,1],[25,6,25,7],[14,4,14,5],[15,4,15,5],[16,2,16,3],[17,2,17,3],[18,2,18,3],[14,2,14,3],[13,0,13,1],[13,4,13,5],[13,2,13,3],[25,4,25,5],[16,0,16,1],[18,0,18,1],[27,0,27,10],[3,9,3,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[10,0,10,1],[11,0,11,1],[12,0,12,1],[11,4,11,5],[12,4,12,5],[8,4,8,5],[9,4,9,5],[10,2,10,3],[11,2,11,3],[12,2,12,3],[15,9,15,10],[16,9,16,10],[20,1,22,4],[4,0,4,1],[17,9,17,10],[5,0,5,1],[18,9,18,10],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[16,4,16,5],[17,4,17,5],[18,4,18,5],[3,2,3,3],[3,0,3,1],[15,2,15,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[17,0,17,1],[10,4,10,5]]}
[]
[null,null,null,null,null,null,null,null,"Receipt #"]
["Cashiers' Cash & Checks Deposit Form",null,null,null,null,null,null,null,"Date",{"$f":"TEXT(TODAY(),\"mm/dd/yy\")","v":"04/28/17"}]
["Check #\n(If Applicable)",null,"Payer Name",null,"Description\n(30 Characters)",null,"Amount","Index/\nFund","Account","Type"]
[null,null,null,null,null,null,null,null,null,null,null,null,"General Revenue"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expense Recovery"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gift or Grant"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Total Deposit",{"$f":"SUM(G5:G19)+SUM(G33:G60)","v":0}]
[]
[null,null,null,null,null,"Total Checks",{"$f":"G20-G23","v":0}]
[null,null,null,null,null,"Total Cash",{"$f":"SUM(SUMIFS(G5:G19,A5:A19,{\"\",\"cash\",\"n/a\",\"none\",\"na\",\"not applicable\",\"coin\",\"change\"}))+SUM(SUMIFS(G33:G60,A33:A60,{\"\",\"cash\",\"n/a\",\"none\",\"na\",\"not applicable\",\"coin\",\"change\"}))","v":0}]
[null,"Special Instructions/Notes"]
[]
[]
[null,"Preparer Name",null,null,"Department",null,"Campus Phone",null,"Email"]
["Complete the form and attach supporting documentation and the cash/checks being deposited.  Submit two copies in person to the Cashiers' Office located in Queally Center.  Do not send any deposits via campus mail.  Retain a copy for your records."]
[null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)","v":"5W8014"}]
[]
[]
["Check #\n(If Applicable)",null,"Payer Name",null,"Description\n(30 Characters)",null,"Amount","Index/\nFund","Account","Type"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J29","v":"5W8014"}]

{"sheet":"Instructions","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,9],[14,1,14,9],[3,0,8,9],[15,0,28,0],[34,2,34,9],[10,1,10,9],[11,1,11,9],[12,1,12,9],[13,1,13,9],[29,0,34,0],[32,2,32,9],[26,2,26,9],[30,2,30,16383]]}
["Instruction's for Cashiers Cash & Checks Deposit Form"]
[]
["General"]
["The Cashier's Cash & Checks Deposit Forms should be used to make cash and check deposits for all departments on campus.  All the information needed to complete a deposit should be entered into the yellow shaded areas on the form.  Each check or cash payment received should be on a separate line and never batched in a single line.  It is important to provide all applicable information and include any required supporting documentation with the form.  Once complete, two copies of the deposit form should be taken to the Cashier's Office.  All deposits must be made in person."]
[]
[]
[]
[]
[]
["Form Details"]
["Check #","Checks must be listed individually.  Include the check number that is located in the top right hand corner of the check.  For cash deposits, leave blank.  "]
["Payer Name","The person(s)/organization on the check or the person(s)/organization paying cash.  Cash and coin may be aggregated."]
["Description","A brief (30 characters or less) description of the transaction.  "]
["Amount","Dollars deposited in US dollars.  If you have a check drawn on a non US bank, please contact "]
["Index/Fund","Checks or cash should be deposited to a specific Index or Fund in Banner.  Fund should be used only when the account code requested is a 1xxx, 2xxx, 4xxx, or 9xxx account code number."]
["Account","5xxx - Revenue Account - MOST COMMON"]
[null,null,"Frequently Used Revenue Account Codes:"]
[null,null,5890,"Miscellaneous"]
[null,null,5609,"Other Sales"]
[null,null,5819,"Other Rentals"]
[null,null,5928,"Off Campus Revenue"]
[null,null,5813,"Facilities Rental"]
[null,null,5801,"Registrations"]
[null,"7xxx - Expense Account - Used for Expense Recovery"]
[null,null,"Please read about what is required for an Expense Recovery below. "]
[null,"1xxx or 2xxx Account - RARELY USED"]
[null,null,"Typically this would be used for a recording sales tax or deposit on some future event/transaction.  For example, a check for a deposit on a wedding event would use a 2xxx account code.  "]
[null,"4xxx or 9xxx - CONTACT ACCOUNTING OFFICE"]
[null,"6xxx, 8xxx, 3xxx - NEVER PERMITTED"]
["Type","General Revenue"]
[null,null,"Use with 5xxx account codes.  Also would be used for 1xxx or 2xxx account codes that relate to certain revenue related activities.  Deposits to 1xxx or 2xxx account codes are uncommon."]
[null,"Expense Recovery"]
[null,null,"An expense recovery is when the University paid for goods or services that should have been paid by another entity.  This can result from cost sharing between entities, error, returning a travel advance, refund check from a vendor, or from the University acting as a pass-through for another entity.  A copy of the invoice or other supporting documentation showing the cost to be recovered must be included with the deposit form.  Further, an explanation on how and why this expense recovery exists must be included in the notes section of the deposit form."]
[null,"Gifts or Grants"]
[null,null,"Please contact the Development Office or Grants Office if selecting."]
["Other Information"]
["Other helpful information or instructions should be added to the Special Instructions/Notes box.  The preparers name, department, campus phone, and email are all required."]